-
Re: Index Collect or Index Match
Hey @Michelle Fayed Your approaches are good, its the syntax that needs to be tweaked. With only one criteria, typically INDEX/MATCH is used. =INDEX({Status}, MATCH([Service Request #]@row, {Service …1 · -
Re: Default one field value based on item selected in another fields dropdown
Hey @k_Hunter001 I'm sorry for the delay. I took advantage of the US holiday week. Your Sponsor-Approver field must be a contact field if you intend to use this field to send notifications. If you do…1 · -
Re: Default one field value based on item selected in another fields dropdown
Hey @k_Hunter001 To make the formula always populate new rows you will want to turn the formula into a column formula. You do this by right clicking INTO the cell where the correct formula resides, a…1 · -
Re: Default one field value based on item selected in another fields dropdown
Hey @k_Hunter001 If these criteria given above are not met, then is the response "(Not Required)"? The screenshot above is truncated so I cannot see the full response. Is there ever a time …2 · -
Re: What view are you? Share your story and claim your badge
Picture a bustling laboratory with samples needing refrigeration, and an industrial sized laboratory refrigerator jam-packed with racks of testtubes and vials. Locating the right rack with your neede…1 ·